package TOP_Version1;

public class Top_JDBC_SQL {

	protected final String LoginAdminSelect = "SELECT ADMIN_NAME FROM ADMIN_INFO WHERE ADMIN_ID = ? AND ADMIN_PW = ?";
	protected final String LoginProfSelect = "SELECT PROF_NAME FROM PROFESSOR WHERE PROF_NO = ? AND PROF_PW = ?";
	protected final String LoginStdSelect = "SELECT STD_NAME FROM STUDENT WHERE STD_NO = ? AND STD_PW = ?";
	
	protected final String AdminCheckSQL = "SELECT ADMIN_ID FROM ADMIN_INFO WHERE ADMIN_ID = ?";
	protected final String AdminInsertSQL = " INSERT INTO ADMIN_INFO VALUES ( ADINFO.NEXTVAL, ?, ?, ?, ?, SYSDATE )";
	protected final String AdminSelectAllSQL = "SELECT * FROM ADMIN_INFO WHERE ADMIN_ID = ?";
	protected final String AdminSelectAll1SQL = "SELECT ADMIN_ID, ADMIN_NAME, ADMIN_TEL, REG_DATE FROM ADMIN_INFO ORDER BY ADMIN_TR";
	protected final String AdminSelectAll2SQL = "SELECT ADMIN_ID, ADMIN_NAME, ADMIN_TEL, REG_DATE FROM ADMIN_INFO WHERE ADMIN_ID = ?";
	protected final String AdminSelectIdSQL = "SELECT ADMIN_ID, ADMIN_NAME, ADMIN_TEL, REG_DATE FROM ADMIN_INFO WHERE ADMIN_ID = ? ORDER BY ADMIN_TR";
	protected final String AdminSelectNameSQL = "SELECT ADMIN_ID, ADMIN_NAME, ADMIN_TEL, REG_DATE FROM ADMIN_INFO WHERE ADMIN_NAME = ? ORDER BY ADMIN_TR";
	protected final String AdminUpdateSQL = "UPDATE ADMIN_INFO SET ADMIN_NAME = ?, ADMIN_PW = ?, ADMIN_TEL = ? WHERE ADMIN_ID = ?";
	protected final String AdminDeleteSQL = "DELETE FROM ADMIN_INFO WHERE ADMIN_ID = ?";
	
	protected final String ProfessorInsertSQL = "INSERT INTO PROFESSOR VALUES ( PRO_SEQ.NEXTVAL, ?, ?, ?, ?, ?, ?, SYSDATE )";
	protected final String ProfessorSelectAllSQL = "SELECT PROF_NO, PROF_NAME, PROF_TEL, PROF_ADDR, PROF_OFFICE, REG_DATE FROM PROFESSOR WHERE PROF_NO = ?";
	protected final String ProfessorSelectAll1SQL = "SELECT PROF_NO, PROF_NAME, PROF_TEL, PROF_ADDR, PROF_OFFICE, REG_DATE FROM PROFESSOR ORDER BY PROF_TR";
	protected final String ProfessorSelectNoSQL = "SELECT PROF_NO, PROF_NAME, PROF_TEL, PROF_ADDR, PROF_OFFICE, REG_DATE FROM PROFESSOR WHERE PROF_NO = ? ORDER BY PROF_TR";
	protected final String ProfessorSelectNameSQL = "SELECT PROF_NO, PROF_NAME, PROF_TEL, PROF_ADDR, PROF_OFFICE, REG_DATE FROM PROFESSOR WHERE PROF_NAME = ? ORDER BY PROF_TR";
	protected final String ProfessorUpdateSQL = "UPDATE PROFESSOR SET PROF_PW = ?, PROF_NAME = ?, PROF_TEL = ?, PROF_OFFICE = ? WHERE PROF_NO = ?";
	protected final String ProfessorDeleteSQL = "DELETE FROM PROFESSOR WHERE PROF_NO = ?";
	
	protected final String DapartinfoSQL = "SELECT * FROM DEPART WHERE PROF_NO = ?";
	
	

}
